SELECT INTERVAL 2 year;
SELECT INTERVAL 2 years;
SELECT INTERVAL '2 years';
SELECT INTERVAL 2 month;
SELECT INTERVAL 2 months;
SELECT INTERVAL '2 months';
SELECT INTERVAL 2 week;
SELECT INTERVAL 2 weeks;
SELECT INTERVAL '2 weeks';
SELECT INTERVAL 2 day;
SELECT INTERVAL 2 days;
SELECT INTERVAL '2 days';
SELECT INTERVAL 2 hour;
SELECT INTERVAL 2 hours;
SELECT INTERVAL '2 hours';
SELECT INTERVAL 2 minute;
SELECT INTERVAL 2 minutes;
SELECT INTERVAL '2 minutes';
SELECT DATE_ADD(hour, 2, toDateTime(1234567890, 'UTC'));
SELECT DATE_ADD(hours, 2, toDateTime(1234567890, 'UTC'));
SELECT DATE_ADD(toDateTime(1234567890, 'UTC'), INTERVAL 2 day);
SELECT DATE_ADD(toDateTime(1234567890, 'UTC'), INTERVAL 2 days);
SELECT DATE_ADD(toDateTime(1234567890, 'UTC'), INTERVAL '2 days');
